object frmStoreGoods: TfrmStoreGoods
  Left = 0
  Top = 0
  Caption = 'Store Goods Info'
  ClientHeight = 538
  ClientWidth = 900
  Color = clBtnFace
  Font.Charset = DEFAULT_CHARSET
  Font.Color = clWindowText
  Font.Height = -11
  Font.Name = 'Tahoma'
  Font.Style = []
  OldCreateOrder = False
  OnCreate = FormCreate
  OnDestroy = FormDestroy
  PixelsPerInch = 96
  TextHeight = 13
  object dbgdStoreGoods: TDBGridEh
    Left = 0
    Top = 41
    Width = 900
    Height = 497
    Align = alClient
    DataGrouping.GroupLevels = <>
    DataSource = dsStoreGoods
    Flat = False
    FooterColor = clWindow
    FooterFont.Charset = DEFAULT_CHARSET
    FooterFont.Color = clWindowText
    FooterFont.Height = -11
    FooterFont.Name = 'Tahoma'
    FooterFont.Style = []
    FooterRowCount = 1
    IndicatorOptions = [gioShowRowIndicatorEh]
    ReadOnly = True
    SumList.Active = True
    TabOrder = 1
    TitleFont.Charset = DEFAULT_CHARSET
    TitleFont.Color = clWindowText
    TitleFont.Height = -11
    TitleFont.Name = 'Tahoma'
    TitleFont.Style = []
    Columns = <
      item
        EditButtons = <>
        FieldName = 'style'
        Footer.Alignment = taRightJustify
        Footer.Value = 'Record'
        Footer.ValueType = fvtStaticText
        Footers = <>
        Title.Caption = #27454#24335
      end
      item
        EditButtons = <>
        FieldName = 'barcode'
        Footer.Alignment = taRightJustify
        Footer.FieldName = 'barcode'
        Footer.ValueType = fvtCount
        Footers = <>
        Width = 83
      end
      item
        EditButtons = <>
        FieldName = 'code'
        Footers = <>
        Width = 200
      end
      item
        EditButtons = <>
        FieldName = 'name'
        Footer.Alignment = taRightJustify
        Footer.Value = 'Total'
        Footer.ValueType = fvtStaticText
        Footers = <>
        Title.Caption = #21517#31216
        Width = 246
      end
      item
        EditButtons = <>
        FieldName = 'qty'
        Footer.FieldName = 'qty'
        Footer.ValueType = fvtSum
        Footers = <>
        Title.Caption = #25968#37327
      end
      item
        EditButtons = <>
        FieldName = 'size'
        Footers = <>
        Title.Caption = #22823#23567
      end
      item
        EditButtons = <>
        FieldName = 'brand'
        Footers = <>
        Title.Caption = #21697#29260
      end
      item
        EditButtons = <>
        FieldName = 'color'
        Footers = <>
        Title.Caption = #39068#33394
      end
      item
        EditButtons = <>
        FieldName = 'gender'
        Footers = <>
        Title.Caption = #24615#21035
      end
      item
        EditButtons = <>
        FieldName = 'grade'
        Footers = <>
        Title.Caption = #31561#32423
      end
      item
        EditButtons = <>
        FieldName = 'producer'
        Footers = <>
        Title.Caption = #20135#22320
      end
      item
        EditButtons = <>
        FieldName = 'salePrice'
        Footers = <>
        Title.Caption = #38144#21806#20215
      end
      item
        EditButtons = <>
        FieldName = 'standard'
        Footers = <>
        Title.Caption = #26631#20934
        Width = 163
      end
      item
        EditButtons = <>
        FieldName = 'storeCode'
        Footers = <>
      end
      item
        EditButtons = <>
        FieldName = 'material'
        Footers = <>
        Title.Caption = #25104#20221'1'
        Width = 400
      end
      item
        EditButtons = <>
        FieldName = 'material2'
        Footers = <>
        Title.Caption = #25104#20221'2'
        Width = 400
      end
      item
        EditButtons = <>
        FieldName = 'material3'
        Footers = <>
        Title.Caption = #25104#20221'3'
        Width = 400
      end
      item
        EditButtons = <>
        FieldName = 'material4'
        Footers = <>
        Title.Caption = #25104#20221'4'
        Width = 400
      end
      item
        EditButtons = <>
        FieldName = 'Description'
        Footers = <>
        Title.Caption = #25551#36848
        Width = 373
      end
      item
        EditButtons = <>
        FieldName = 'kind'
        Footers = <>
        Title.Caption = #22823#20998#31867
        Width = 170
      end
      item
        EditButtons = <>
        FieldName = 'item'
        Footers = <>
        Title.Caption = #23567#20998#31867
        Width = 177
      end
      item
        EditButtons = <>
        FieldName = 'Collection'
        Footers = <>
        Title.Caption = #31995#21015
        Width = 210
      end
      item
        EditButtons = <>
        FieldName = 'othercode'
        Footers = <>
        Width = 228
      end>
    object RowDetailData: TRowDetailPanelControlEh
    end
  end
  object pnlSearch: TPanel
    Left = 0
    Top = 0
    Width = 900
    Height = 41
    Align = alTop
    TabOrder = 0
    DesignSize = (
      900
      41)
    object btnSearch: TButton
      Left = 13
      Top = 10
      Width = 75
      Height = 25
      Caption = #24320#22987#25628#32034
      TabOrder = 0
      OnClick = btnSearchClick
    end
    object btnExport: TButton
      Left = 815
      Top = 10
      Width = 75
      Height = 25
      Anchors = [akTop, akRight]
      Caption = #23548#20986
      TabOrder = 1
      OnClick = btnExportClick
    end
  end
  object myqrystoreGoods: TMyQuery
    Connection = DMMySQL.conMySQL
    SQL.Strings = (
      
        'select gi.*,sgi.storeCode,sgi.Qty from storegoodsinfo sgi left j' +
        'oin goodsinfo gi on sgi.goodsid=gi.id')
    ReadOnly = True
    KeyFields = 'id'
    Left = 144
    Top = 104
  end
  object dsPrdStoreGoods: TDataSetProvider
    DataSet = myqrystoreGoods
    UpdateMode = upWhereKeyOnly
    OnUpdateError = dsPrdStoreGoodsUpdateError
    Left = 208
    Top = 104
  end
  object cdsStoreGoods: TClientDataSet
    Aggregates = <>
    Params = <>
    ProviderName = 'dsPrdStoreGoods'
    Left = 304
    Top = 112
    object cdsStoreGoodsid: TLargeintField
      FieldName = 'id'
    end
    object cdsStoreGoodsbarcode: TWideStringField
      FieldName = 'barcode'
    end
    object cdsStoreGoodscode: TWideStringField
      FieldName = 'code'
      Size = 50
    end
    object cdsStoreGoodsname: TWideStringField
      FieldName = 'name'
      Size = 50
    end
    object cdsStoreGoodsbrand: TWideStringField
      FieldName = 'brand'
    end
    object cdsStoreGoodsstyle: TWideStringField
      FieldName = 'style'
    end
    object cdsStoreGoodsgender: TWideStringField
      FieldName = 'gender'
      Size = 10
    end
    object cdsStoreGoodssize: TWideStringField
      FieldName = 'size'
      Size = 15
    end
    object cdsStoreGoodsSIZEGD: TWideStringField
      FieldName = 'SIZEGD'
      Size = 15
    end
    object cdsStoreGoodsseason: TWideStringField
      FieldName = 'season'
      Size = 4
    end
    object cdsStoreGoodscolor: TWideStringField
      FieldName = 'color'
      Size = 10
    end
    object cdsStoreGoodsgrade: TWideStringField
      FieldName = 'grade'
      Size = 10
    end
    object cdsStoreGoodsproducer: TWideStringField
      FieldName = 'producer'
      Size = 30
    end
    object cdsStoreGoodsmaterial: TWideStringField
      FieldName = 'material'
      Size = 200
    end
    object cdsStoreGoodsqty: TIntegerField
      FieldName = 'qty'
    end
    object cdsStoreGoodssalePrice: TFloatField
      FieldName = 'salePrice'
    end
    object cdsStoreGoodsstoreCode: TWideStringField
      FieldName = 'storeCode'
      Size = 10
    end
    object cdsStoreGoodsDescription: TWideStringField
      FieldName = 'Description'
      Size = 255
    end
    object cdsStoreGoodsstandard: TWideStringField
      FieldName = 'standard'
      Size = 100
    end
    object cdsStoreGoodsmaterial2: TWideStringField
      FieldName = 'material2'
      Size = 200
    end
    object cdsStoreGoodsmaterial3: TWideStringField
      FieldName = 'material3'
      Size = 200
    end
    object cdsStoreGoodsmaterial4: TWideStringField
      FieldName = 'material4'
      Size = 200
    end
    object cdsStoreGoodskind: TWideStringField
      FieldName = 'kind'
      Size = 200
    end
    object cdsStoreGoodsitem: TWideStringField
      FieldName = 'item'
      Size = 200
    end
    object cdsStoreGoodsCollection: TWideStringField
      FieldName = 'Collection'
      Size = 50
    end
    object cdsStoreGoodsothercode: TWideStringField
      FieldName = 'othercode'
      Size = 100
    end
  end
  object dsStoreGoods: TDataSource
    DataSet = cdsStoreGoods
    Left = 376
    Top = 112
  end
end
